{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Marine Plotting Tools","Worksheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Marine Plotting Tools","index":0,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,19,3,21],[4,19,4,21],[13,16,13,18],[14,16,14,18],[10,16,10,18],[11,19,11,21],[12,19,12,21],[7,19,7,21],[8,19,8,21],[10,19,10,21],[11,16,11,18],[12,16,12,18],[7,16,7,18],[8,16,8,18],[3,16,3,18],[4,16,4,18]]}
[]
[null,"Total Vector",null,null,null,"Other Calculations",null,null,null,null,null,null,null,null,"Conversions"]
[null,"Vector","Direction (deg)","Rate (Nm)",null,null,"Total Water Current",null,null,null,"Distance / Time",null,null,null,null,"Distance / Speed"]
[null,1,null,null,null,null,"Flow rate (Kts)",null,null,null,"Distance (Nm)",null,{"$f":"IFERROR(IF(L4<>\"\",L4,IF(L5*L6=0,\"\",L5*L6)),\"\")","v":""},null,null,"Nm/Kts to Km/Kph",null,null,null,{"$f":"IF(Q4=\"\",\"\",TEXT(Q4*1.852,\"#.00\"))","v":""}]
[null,2,null,null,null,null,"Time (dec hrs)",null,null,null,"Speed (Kts)",null,{"$f":"IFERROR(IF(L5<>\"\",L5,L4/L6),\"\")","v":""},null,null,"Km/Kph to Nm/Kts",null,null,null,{"$f":"IF(Q5=\"\",\"\",TEXT(Q5*0.539957,\"#.00\"))","v":""}]
[null,3,null,null,null,null,"Tide direction (deg)",null,null,null,"Time (dec hrs)",null,{"$f":"IFERROR(IF(L6<>\"\",L6,IF(L4*L5=0,\"\",L4/L5)),\"\")","v":""}]
[null,4,null,null,null,null,null,{"$f":"IF(H4=\"\",\"\",H4*H5&\" Nm\")","v":""},{"$f":"IF(H7=\"\",\"\",\"@ \"&H6&\" (T)\")","v":""},null,null,null,null,null,null,"Time Format"]
[null,5,null,null,null,null,"Leeway",null,null,null,"Coverage Factor",null,null,null,null,"hh:mm to hh.hh",null,null,null,{"$f":"IF(Q8=\"\",\"\",HOUR(Q8)+(MINUTE(Q8)/60))","v":""}]
[null,6,null,null,null,null,"Wind speed (Kts)",null,null,null,"Uncorrected Sweep Width (Nm)",null,null,null,null,"hh.hh to hh:mm",null,null,null,{"$f":"IF(Q9=\"\",\"\",INT(Q9)&\":\"&INT((Q9-TRUNC(Q9))*60))","v":""}]
[null,7,null,null,null,null,"Multiplier",null,null,null,"Weather correction"]
[null,8,null,null,null,null,"Modifier",null,null,null,"Fatigue",null,null,null,null,"Time Difference","Date",null,null,"Time"]
[null,9,null,null,null,null,"Result (Kts)",{"$f":"IF(H9=\"\",\"\",H9*IF(OR(H10=\"\",H10=0),1,H10)+H11)","v":""},null,null,"Corrected Sweep Width",null,{"$f":"IF(L9=\"\",IF(OR(L14=\"\",L15=\"\"),\"\",L14*L15),IF(AND(L9<>\"\",L10<>\"\",L11<>\"\"),L9*L10*L11,IF(AND(L10=\"\",L11=\"\"),L9,IF(L10<>\"\",L9*L10,L9*L11))))","v":""},null,null,"IPP time"]
[null,10,null,null,null,null,"Time (dec hrs)",null,null,null,null,null,null,null,null,"Search start"]
[null,11,null,null,null,null,"Wind direction (deg)",null,null,null,"Coverage (%)",null,{"$f":"IFERROR(IF(L14<>\"\",L14,M12/L15),\"\")","v":""},null,null,"Difference (hh:mm)",{"$f":"IF(OR(Q12=\"\",Q13=\"\"),IF(OR(T12=\"\",T13=\"\"),\"\",IF(T13<T12,\"\",T13-T12)),IF(OR(T12=\"\",T13=\"\"),\"\",IF((Q13+T13)<(Q12+T12),\"\",(Q13+T13)-(Q12+T12))))","v":""}]
[null,12,null,null,null,null,null,{"$f":"IF(H9=\"\",\"\",TEXT(H12*H13,\"#.00\")&\" Nm\")","v":""},{"$f":"IF(H15=\"\",\"\",\"@ \"&IF(H14+180>360,(H14+180)-360,H14+180)&\" (T)\")","v":""},null,"Track Spacing (Nm)",null,{"$f":"IFERROR(IF(L15<>\"\",L15,IF(M12/L14=0,\"\",M12/L14)),\"\")","v":""},null,null,"Difference (hh.hh)",{"$f":"IF(Q14=\"\",\"\",LEFT(TEXT(Q14,\"[h]:mm\"),FIND(\":\",TEXT(Q14,\"[h]:mm\"))-1)+(MINUTE(Q14)/60))","v":""}]
[null,13,null,null,null,null,"Search Area Radius"]
[null,14,null,null,null,null,"TDV (Nm)",null,null,null,"Area / Time",null,null,null,null,"Coordinates","D","M","S",null,"D","M.mm"]
[null,15,null,null,null,null,"Unmodified radius (Nm)",{"$f":"IF(H17=\"\",\"\",6)","v":""},null,null,"Area (Nm2)",null,{"$f":"IFERROR(IF(L18<>\"\",L18,IF(L19*L20*L21=0,\"\",L19*L20*L21)),\"\")","v":""},null,null,"Latitude",null,null,null,null,{"$f":"IF(Q18=\"\",\"\",Q18)","v":""},{"$f":"IF(R18=\"\",IF(S18=\"\",\"\",R18+(S18/60)),R18+(S18/60))","v":""}]
[null,16,null,null,null,null,"Modified radius (Nm)",{"$f":"IF(H17>8,H18+H17/8,H18)","v":""},null,null,"Time (dec hrs)",null,{"$f":"IFERROR(IF(L19<>\"\",L19,L18/(L20*L21)),\"\")","v":""},null,null,"Longitude",null,null,null,null,{"$f":"IF(Q19=\"\",\"\",Q19)","v":""},{"$f":"IF(R19=\"\",IF(S19=\"\",\"\",R19+(S19/60)),R19+(S19/60))","v":""}]
[null,17,null,null,null,null,"Search Area (Nm2)",{"$f":"IF(H17=\"\",\"\",(H19*2)*(H19*2))","v":""},null,null,"Velocity (Kts)",null,{"$f":"IFERROR(IF(L20<>\"\",L20,L18/(L19*L21)),\"\")","v":""}]
[null,18,null,null,null,null,null,null,null,null,"Track Spacing (Nm)",null,{"$f":"IFERROR(IF(L21<>\"\",L21,L18/(L19*L20)),\"\")","v":""},null,null,"Latitude",{"$f":"IF(U21=\"\",\"\",U21)","v":""},{"$f":"IF(V21=\"\",\"\",INT(V21))","v":""},{"$f":"IF(V21=\"\",\"\",(V21-INT(V21))*60)","v":""}]
[null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,"Longitude",{"$f":"IF(U22=\"\",\"\",U22)","v":""},{"$f":"IF(V22=\"\",\"\",INT(V22))","v":""},{"$f":"IF(V22=\"\",\"\",(V22-INT(V22))*60)","v":""}]
[null,20]
[null,null,"Total Direction: ",{"$f":"IF(Worksheet!H30=\"NULL\",\"\",TEXT(Worksheet!H30,\"000\")&\" (T)\")","v":""}]
[null,null,"Total Distance: ",{"$f":"IF(Worksheet!H31=0,\"\",TEXT(Worksheet!H31,\"#.00\")&\" Nm\")","v":""}]

{"sheet":"Worksheet","index":1,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Vector","Degrees","Size","Angle in Radians","Sine","Cosine","X","Y"]
[null,1,{"$f":"'Marine Plotting Tools'!C4","v":0},{"$f":"'Marine Plotting Tools'!D4","v":0},{"$f":"RADIANS(C3)","v":0},{"$f":"IF(OR(C3=180,C3=360),0,SIN(E3))","v":0},{"$f":"IF(OR(C3=90,C3=270),0,COS(E3))","v":1},{"$f":"F3*D3","v":0},{"$f":"G3*D3","v":0}]
[null,2,{"$f":"'Marine Plotting Tools'!C5","v":0},{"$f":"'Marine Plotting Tools'!D5","v":0},{"$f":"RADIANS(C4)","v":0},{"$f":"IF(OR(C4=180,C4=360),0,SIN(E4))","v":0},{"$f":"IF(OR(C4=90,C4=270),0,COS(E4))","v":1},{"$f":"F4*D4","v":0},{"$f":"G4*D4","v":0}]
[null,3,{"$f":"'Marine Plotting Tools'!C6","v":0},{"$f":"'Marine Plotting Tools'!D6","v":0},0,0,1,0,0]
[null,4,{"$f":"'Marine Plotting Tools'!C7","v":0},{"$f":"'Marine Plotting Tools'!D7","v":0},0,0,1,0,0]
[null,5,{"$f":"'Marine Plotting Tools'!C8","v":0},{"$f":"'Marine Plotting Tools'!D8","v":0},0,0,1,0,0]
[null,6,{"$f":"'Marine Plotting Tools'!C9","v":0},{"$f":"'Marine Plotting Tools'!D9","v":0},{"$f":"RADIANS(C8)","v":0},{"$f":"IF(OR(C8=180,C8=360),0,SIN(E8))","v":0},{"$f":"IF(OR(C8=90,C8=270),0,COS(E8))","v":1},{"$f":"F8*D8","v":0},{"$f":"G8*D8","v":0}]
[null,7,{"$f":"'Marine Plotting Tools'!C10","v":0},{"$f":"'Marine Plotting Tools'!D10","v":0},0,0,1,0,0]
[null,8,{"$f":"'Marine Plotting Tools'!C11","v":0},{"$f":"'Marine Plotting Tools'!D11","v":0},0,0,1,0,0]
[null,9,{"$f":"'Marine Plotting Tools'!C12","v":0},{"$f":"'Marine Plotting Tools'!D12","v":0},0,0,1,0,0]
[null,10,{"$f":"'Marine Plotting Tools'!C13","v":0},{"$f":"'Marine Plotting Tools'!D13","v":0},0,0,1,0,0]
[null,11,{"$f":"'Marine Plotting Tools'!C14","v":0},{"$f":"'Marine Plotting Tools'!D14","v":0},0,0,1,0,0]
[null,12,{"$f":"'Marine Plotting Tools'!C15","v":0},{"$f":"'Marine Plotting Tools'!D15","v":0},{"$f":"RADIANS(C14)","v":0},{"$f":"IF(OR(C14=180,C14=360),0,SIN(E14))","v":0},{"$f":"IF(OR(C14=90,C14=270),0,COS(E14))","v":1},{"$f":"F14*D14","v":0},{"$f":"G14*D14","v":0}]
[null,13,{"$f":"'Marine Plotting Tools'!C16","v":0},{"$f":"'Marine Plotting Tools'!D16","v":0},0,0,1,0,0]
[null,14,{"$f":"'Marine Plotting Tools'!C17","v":0},{"$f":"'Marine Plotting Tools'!D17","v":0},0,0,1,0,0]
[null,15,{"$f":"'Marine Plotting Tools'!C18","v":0},{"$f":"'Marine Plotting Tools'!D18","v":0},0,0,1,0,0]
[null,16,{"$f":"'Marine Plotting Tools'!C19","v":0},{"$f":"'Marine Plotting Tools'!D19","v":0},0,0,1,0,0]
[null,17,{"$f":"'Marine Plotting Tools'!C20","v":0},{"$f":"'Marine Plotting Tools'!D20","v":0},0,0,1,0,0]
[null,18,{"$f":"'Marine Plotting Tools'!C21","v":0},{"$f":"'Marine Plotting Tools'!D21","v":0},0,0,1,0,0]
[null,19,{"$f":"'Marine Plotting Tools'!C22","v":0},{"$f":"'Marine Plotting Tools'!D22","v":0},0,0,1,0,0]
[null,20,{"$f":"'Marine Plotting Tools'!C23","v":0},{"$f":"'Marine Plotting Tools'!D23","v":0},0,0,1,0,0]
[]
[null,null,null,null,null,null,null,"Xt","Yt"]
[null,null,null,null,null,null,"Total Contribution",{"$f":"SUM(H3:H22)","v":0},{"$f":"SUM(I3:I22)","v":0}]
[null,null,null,null,null,null,"Tan = Opposite / Adjacent",{"$f":"IFERROR(H25/I25,0)","v":0}]
[null,null,null,null,null,null,"Radians",{"$f":"ATAN(H26)","v":0}]
[null,null,null,null,null,null,"Raw degrees",{"$f":"DEGREES(H27)","v":0}]
[null,null,null,null,null,null,"Degrees",{"$f":"IF(H28<0,-H28,H28)","v":0}]
[null,null,null,null,null,null,"Resultant Vector",{"$f":"IF(AND(H25>0,I25>0),H29,IF(AND(H25>0,I25<0),180-H29,IF(AND(H25<0,I25<0),180+H29,IF(AND(H25<0,I25>0),360-H29,IF(AND(H25=0,I25>0),360,IF(AND(H25=0,I25<0),180,IF(AND(I25=0,H25>0),90,I30)))))))","v":"Null"},{"$f":"IF(AND(I25=0,H25<0),270,IF(AND(I25=0,H25=0),\"Null\",\"\"))","v":"Null"}]
[null,null,null,null,null,null,"Size",{"$f":"SQRT((H25*H25)+(I25*I25))","v":0}]